package com.powell.health.dao.table;

import android.provider.BaseColumns;

/**
 * Created with IntelliJ IDEA.
 * User: tpowell
 * Date: 1/5/13
 * Time: 2:18 PM
 * To change this template use File | Settings | File Templates.
 */
public abstract class ItemTable implements BaseColumns {
    public final static String TABLE_NAME = "ITEM";
    public final static String ITEM_ID = "ITEM_ID";
    public final static String CATEGORY_ID = "CATEGORY_ID";
    public final static String ITEM_NAME = "ITEM_NAME";
    public final static String ITEM_DETAIL_ID = "ITEM_DETAIL_ID";
    public final static String CREATE_TABLE =
            "CREATE TABLE IF NOT EXISTS " + TABLE_NAME +
                    " (" + ITEM_ID + " INTEGER PRIMARY KEY autoincrement, " + CATEGORY_ID +" INTEGER, "
                    +ITEM_NAME +" TEXT, " + ITEM_DETAIL_ID + " TEXT)";
}
